package com.denso.store.admin.statistic;

import com.jfinal.core.Controller;

/**
 * Created by lijian on 2018/1/27.
 */
public class StatisticController extends Controller {

    // 统计额外任务
    // select DATE_FORMAT(planTime,'%Y-%m-%d') as ftime, count(adminOpt) from archive where adminOpt=1 group by ftime
    /*
    select DATE_FORMAT(planTime,'%Y-%m-%d') as ftime, count(adminOpt)
    from archive
    where adminOpt=1 and
        DATE_FORMAT(planTime,'%Y-%m-%d')>='2018-02-1' and
        DATE_FORMAT(planTime,'%Y-%m-%d')<='2018-02-28'
    group by ftime
     */
    public void countExtraScheduler() {

    }

    // 获取额外任务详细信息(具体一天额外任务详细信息列表)
    public void getExtraSchedulerList() {

    }

    // 统计迟到车辆
    // select DATE_FORMAT(planTime,'%Y-%m-%d') as ftime, count(lateFlag) from archive where lateFlag=1 group by ftime
    public void countLateVans() {

    }

    // 获取迟到车辆详细信息（具体一天迟到车辆详细信息列表）
    public void getLateVans() {

    }

}
